www.gusucode.com > PHP展示型企业网站模板米拓整站源码 1.0PHP源码程序 > PHP展示型企业网站模板米拓整站源码 1.0/MetInfozs_v1.0/MetInfozs_v1.0/admin/content/feedback/export.php

    <?php
# MetInfo Enterprise Content Management System 
# Copyright (C) MetInfo Co.,Ltd (http://www.metinfo.cn). All rights reserved. 
	ob_start();
	$depth='../';
	require_once $depth.'../login/login_check.php';
	require_once $depth.'../include/common.inc.php';
	ob_clean();
	ob_start();
	require('php_xls.php');
	foreach($settings_arr as $key=>$val){
		if($val['columnid']==$class1){
			$tingname    =$val['name'].'_'.$val['columnid'];
			$$val['name']=$$tingname;
		}
	}
	$query = "SELECT * FROM $met_parameter where module=8 and lang='$lang' order by no_order";
	$result = $db->query($query);
	while($list= $db->fetch_array($result)){
		$feedbackpara[$list['id']]=$list;
		$feedback_para[]=$list;
	}	
	$query = "SELECT * FROM $met_flist where module=8 and lang='$lang'";
	$result = $db->query($query);
	while($list= $db->fetch_array($result)){
		if($feedbackpara[$list['paraid']]['type']==5 and $list[info]<>"")$list[info]=$met_weburl."upload/file/".$list[info];
		$paravalue[$list[listid]][$list[paraid]]=$list;
	}
	if($met_fd_export==-1){
		$where=" ";
	}else{
		$where=" and exists(select info from $met_flist where listid=$met_feedback.id and paraid=$met_fd_class and info='$met_fd_export')";
	}
	$query = "SELECT * FROM $met_feedback where class1='$class1' and lang='$lang' ".$where;
	$result = $db->query($query);
	while($list= $db->fetch_array($result)){
	$list['customerid']=$list['customerid']=='0'?$lang_feedbackAccess0:$list['customerid'];
	  foreach($feedback_para as $key=>$val){
	   $para='para'.$val[id];
	   $list[$para]=$paravalue[$list[id]][$val[id]][info];
	  }
	$feedback_list[]=$list;

	}


	/*set xls*/
	

	$column=array("",$lang_fdeditorInterest);
	$param=array('fdtitle');
	foreach($feedback_para as $key=>$val){
		$column[]=$val['name'];
		$param[]="para".$val[id];
	}
	$column[]=$lang_fdeditorTime;
	$column[]=$lang_fdeditorFrom;
	$column[]=$lang_feedbackID;
	$column[]=$lang_fdeditorRecord;
	$param[]='addtime';
	$param[]='fromurl';
	$param[]='customerid';
	$param[]='useinfo';
	$xls=new PHP_XLS();
	$xls->AddSheet($lang_editor);
	$xls->NewStyle('hd_t');

	$xls->StyleSetFont(0, 10, 0, 1, 0, 0);

	$xls->StyleSetAlignment(0, 0);
	$xls->StyleAddBorder("Top", '#000000', 2);
	$xls->StyleAddBorder("Right", '#000000', 1);
	
	$xls->CopyStyle('hd_t','hd_l');
	$xls->StyleAddBorder("Left", '#000000', 2);

	$xls->CopyStyle('hd_t','hd_r');
	$xls->StyleAddBorder("Right", '#000000', 2);
	
	$xls->SetRowHeight(1,30);

	for($i=1;$i<count($column);$i++)
	{
		$xls->SetColWidth($i,80);
	}
	
	$xls->SetActiveStyle('hd_l');
	$xls->SetActiveStyle('hd_t');
	$xls->SetActiveStyle('hd_r');
	for($i=1;$i<count($column);$i++)
	{
		$xls->Textc(1,$i,$column[$i]);
	}

	
	$xls->NewStyle('center');
	$xls->StyleSetAlignment(0, 0);
	$xls->StyleAddBorder("Top", '#000000', 1);
	$xls->StyleAddBorder("Right", '#000000', 1);
	
	$xls->CopyStyle('center','center_l');
	$xls->StyleAddBorder("Left", '#000000', 2);

	$xls->CopyStyle('center','center_r');
	$xls->StyleAddBorder("Right", '#000000', 2);

	
	/*get feedback infomation *export xls */	
		
	for ($i=0; $i<count($feedback_list); $i++) 
	{		
		
		for ($j=0; $j<count($column)-1; $j++) {
			$xls->SetActiveStyle('center');	
			$xls->Textc($i+2,$j+1,$feedback_list[$i][$param[$j]]);
		}
	}	
	$xls->Output($met_module[8][0][name].".xls");
# This program is an open source system, commercial use, please consciously to purchase commercial license.
# Copyright (C) MetInfo Co., Ltd. (http://www.metinfo.cn). All rights reserved.
?>